IF EXISTS (SELECT *
           FROM INFORMATION_SCHEMA.VIEWS
           WHERE TABLE_NAME='vInProdDetail'
           AND TABLE_SCHEMA='dbo'
          )
          DROP VIEW dbo.vInProdDetail
GO

CREATE VIEW dbo.vInProdDetail
AS
/*@@*_____________________________________________________________________


_____________________________________________________________________*@@*/

  SELECT
    InProdDetail.*,
    InProdPaper.[Date]
  FROM
    InProdDetail
    
    INNER JOIN dbo.InProdPaper
		ON InProdDetail.InProdPaperId = InProdPaper.Id



